/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50525
Source Host           : localhost:3306
Source Database       : ym_welcome

Target Server Type    : MYSQL
Target Server Version : 50525
File Encoding         : 65001

Date: 2012-08-20 17:44:52
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `configs`
-- ----------------------------
DROP TABLE IF EXISTS `configs`;
CREATE TABLE `configs` (
`id`  bigint(20) NOT NULL AUTO_INCREMENT ,
`id_page`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`page_type`  smallint(6) NULL DEFAULT NULL COMMENT '0:for fans page and non-fans page ; 1: only for non-fans page' ,
`content_type`  smallint(6) NULL DEFAULT NULL COMMENT '1:image;2:html-code;3:iframe url' ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'path of image				' ,
`image_url`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'url will be redirect when click image' ,
`html`  text CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`iframe_url`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'url iframe				' ,
`iframe_height`  int(11) NULL DEFAULT 1000 ,
`iframe_hide_scroll`  smallint(6) NULL DEFAULT NULL ,
`created_date`  timestamp NULL DEFAULT NULL ,
`updated_date`  timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of configs
-- ----------------------------
BEGIN;
INSERT INTO configs VALUES ('1', '420230768014855', '0', '2', '', '', '<p><span style=\"color: #ff00ff;\">HTML</span></p>\r\n<p>kkkkkkkkkkkkkk</p>', '', null, null, '1', '0000-00-00 00:00:00', '2012-08-20 17:02:48');
COMMIT;

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`id_social`  varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`email`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`first_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`middle_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`last_name`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`link`  varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`image`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ,
`birthday`  date NULL DEFAULT NULL ,
`gender`  varchar(256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`timezone`  tinyint(2) NULL DEFAULT NULL ,
`locale`  varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`time_created`  int(11) NOT NULL ,
`time_modified`  int(11) NOT NULL ,
`time_social_modified`  int(11) NOT NULL ,
`role`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`ref`  varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
`extended_access_token`  varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_unicode_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO users VALUES ('1', '100000338832551', 'ptnhuan@gmail.com', 'Phan Thanh Nhuan', 'Phan', 'Thanh', 'Nhuan', 'http://www.facebook.com/ptnhuan', 'http://graph.facebook.com/100000338832551/picture', null, 'male', '7', 'en_US', '1343636453', '1343636453', '1343615666', '', 'notif', 'AAADjin7DxTgBAHgz3pNgAiJnc7vcP45mrCgpZAZBxVjKKXPA9OnkWIyYcAGrpJFM1ZAhIuM3iGFla0VPu6ZA9mH1IuSHmbk4JAZCZBgO3gJgZDZD'), ('2', '100003109618128', 'ptnhuanfr@gmail.com', 'Hoang Tam', 'Hoang', null, 'Tam', 'http://www.facebook.com/ishangu', 'http://graph.facebook.com/100003109618128/picture', null, 'male', '7', 'en_US', '1343635956', '1343635956', '1343613639', '', 'notif', 'AAADjin7DxTgBAInJSejd09IkDuLSKivhVL7QgbyZCiZBlkWF8AmZA66EQvNX0qaZC2waPmqiJxb32nivMXe8DBme2bLvhizsmojV3UM7jgZDZD'), ('3', '100004013036929', 'send.media.social@gmail.com', 'Jessica Lee', 'Jessica', null, 'Lee', 'http://www.facebook.com/profile.php?id=100004013036929', 'http://graph.facebook.com/100004013036929/picture', null, 'female', '7', 'en_US', '1344483646', '1344483646', '1344423437', '', null, 'AAAFvgSZC4cZAUBAFKWERIsHxpyCslwTqZB4wz2RfcvDF74jEBS2DfmMXmZCJZB0wwbS1tqimqqg4Lzkx9nPzycwSr87C3FOYBgZB1c8VfUCAZDZD');
COMMIT;

-- ----------------------------
-- Auto increment value for `configs`
-- ----------------------------
ALTER TABLE `configs` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table `users`
-- ----------------------------
CREATE UNIQUE INDEX `id_social` ON `users`(`id_social`) USING BTREE ;

-- ----------------------------
-- Auto increment value for `users`
-- ----------------------------
ALTER TABLE `users` AUTO_INCREMENT=4;
